论坛精华
>> Oracle 专栏
>> A 7-5 Obtaining Information About Archiving [查看别人的评论]
由 macro 发布于: 2001-03-01 19:09
The following sql command shows the database log mode and if the automatic archival is enabled:
SQL> ARCHIVE LOG LIST;
为什么我看到 “ORA-01031: 权限不足”？我是用的 system 和 sys 用户进去看的。
Query the dynamic performance views V$DATABASE and V$INSTANCE to show the database log mod and the archiving mode.
SQL> select name, log_mode
2 from v$database;
NAME LOG_MODE
--------- ------------
EDITOR NOARCHIVELOG
SQL> SELECT archiver FROM v$instance;
ARCHIVE
-------
STOPPED
__________________
谢谢你抽时间看我的发言，
Macro Zeng
==================================
我正在学习 Oracle ,坚持每天写读书笔记
|
